
<!DOCTYPE html>
<html>
	<head>
	    <title>订单管理</title>
	    <meta charset="UTF-8">
	    <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css" />
	    <link rel="stylesheet" type="text/css" href="css/bootstrap-responsive.min.css" />
	    <link rel="stylesheet" type="text/css" href="css/style.css" />
	    <script type="text/javascript" src="js/jquery.min.js"></script>  
	</head>
<?php
session_start();
error_reporting(5);

include_once('../dbtools.inc.php');
include_once('../config.php');
// include_once('back_order_list.php');
$goods=$_POST['gsn'];
	$field=$goods;
	       if($field!=""){
	       	$sql="SELECT * FROM goods WHERE goodsid like '%$field%' AND hot='1' AND state='0'";
	       	$result = mysqli_query($config,$sql) or die ('SQL语句有误：'.mysqli_error());
// $row_sql=mysqli_fetch_array($result);

	       }


	       

// error_reporting(E_ALL & ~E_NOTICE);
// error_reporting(0);
	?>

	<body>
		<form class="form-inline definewidth m20" action="#" method="post">
			商品查询：<input name="gsn" id="search" class="abc input-default" value="" ></input>&nbsp;&nbsp;
			<button type="submit" class="btn btn-primary" >查询</button>&nbsp;&nbsp; 
		    
		</form>
		<table class="table table-bordered table-hover definewidth m10" style="position: relative;">
		    <thead>
			    <tr >
					<th style="text-align: center;">商品id</th>
			        <th style="text-align: center;">商品名称</th>
			        <th style="text-align: center;">商品详情</th>
			        <th style="text-align: center;">商品图片</th>
			        <th style="text-align: center;">型号码数</th>
			        <th style="text-align: center;">类型</th>
			        <th style="text-align: center;">状态</th>
			        <th style="text-align: center;">库存</th>
			        <th style="text-align: center;">发布时间</th>
			        <th style="text-align:center;">操作</th>
			    </tr>
		    </thead>

             <?php while ($ro=mysqli_fetch_array($result)){
// $query="SELECT * FROM users WHERE userid='".$row_sql['userid']."'";
// $result=mysqli_query($config,$query);
// $row=mysqli_fetch_array($result);
// var_dump($row);

             	?>
			<tr >
				<td style="text-align: center;"><?php echo $ro['goodsid'];?></td>
				<td style="text-align: center;"><?php echo $ro['goodsname'];?></td>
				<td style="text-align: center;"><?php echo $ro['intro'];?></td>
				<td style="width:80px;height: 80px;"><img src="../images/goods/<?php echo $ro['bigtypeid'];?>/<?php echo $ro['smalltypeid'];?>/<?php echo $ro['picture'];?>" style="width: 100%;height: 100%;"></td>
				<td style="text-align: center;"><?php echo $ro['xinghao'];?></td>
				<td style="text-align: center;"><?php echo $ro['leixing'];?></td>
				<td style="text-align: center;"><?php echo $ro['zhuangtai'];?></td>				
				<td style="text-align: center;"><?php echo $ro['kucun'];?></td>
				<td style="text-align: center;"><?php echo $ro['pub_time'];?></td>
				<td style="text-align:center; width: 100px;font-size: 15px;">                
					<a href="back_tuijian_cxtg.php?id=<?php echo $v['goodsid']?>" onclick="return confirm('是否撤销推荐？');">撤销推荐</a>&nbsp;           
				</td>
			</tr>
            <?php } ?>

		</table>
	</body>
</html>